if exists (select name from sysobjects where name like 'Proc_TruSo_GetById')
	drop procedure Proc_TruSo_GetById
go

create PROC Proc_TruSo_GetById (@maTruSo int )
as
	select * from TruSo
	where @maTruSo= TruSo.MaTruSo
go

Exec Proc_TruSo_GetById 1
go

----------------------------------------
if exists (select name from sysobjects where name like 'Proc_TruSo_GetALL')
	drop procedure Proc_TruSo_GetALL
go

create PROC Proc_TruSo_GetALL ( @delFlg int )
as
	select * from TruSo
	where @delFlg = DelFlg
go

Exec Proc_TruSo_GetALL 0
go
